package com.example.newjiesai.openplant.dao;


import com.example.newjiesai.entity.Point;
import org.springframework.stereotype.Repository;

@Repository
public class Point_dao extends Base_dao {

    public void updateCase() {
        String sql = "update Point set ED='测试' where ID=1024;";
        executeSQL(sql);
    }

    public void selectCase() {
        String sql = "select * from Point limit 10";
        executeSelectSQL(sql);
    }

    public void deleteCase() {
        String sql = "delete from  Point where ID=1024;";
        executeSQL(sql);
    }

    public void insert(Point data) {
        String GN = data.getGN();
        int RT = data.getRT();
        String sql = "insert into Point (GN,RT) values ('"+GN+"','"+RT+"');";
        executeSQL(sql);
    }
}
